<!DOCTYPE html PUBLIC "-//W3C//Dth XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/Dth/xhtml1-transitional.dth">
<!--#include file="DataLoad.asp"-->

<html>
<head>
<title><%=GuildName%> - DKP系统</title>
<script language="JavaScript" src="inc/jquery.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta name="Generator" content="EditPlus">
<meta name="Author" content="SULei">
<meta name="Keywords" content="DKP WOW GUILD">
<meta name="Description" content="">
<link href="<%=StylePath%>/main.css" rel="stylesheet" type="text/css" />
<script language="JavaScript" src="<%=StylePath%>/styleplus.js"></script>
<style type="text/css" media="all">

</style>
<!--#include file="inc/ajax.asp"-->
</head>

<body>
<div class="header">
<!--#include file="menu.asp"-->
</div>
<div class="main">
<%
Dim HtmlLooted
Call Looted()
%>
</div>
<div id="footer"><!--#include file="footer.asp"--></div>
</body>
</html>
<%
Sub Looted()
	if request.form("keyword")<>"" then
		sql="select * from raid_event where event_class='拾取' and event_object2 like '%"&request.form("keyword")&"%' order by event_time"
	elseif request("keyword")<>"" then
		sql="select * from raid_event where event_class='拾取' and event_object2 like '%"&request("keyword")&"%' order by event_time"
	else
		sql="select * from raid_event where event_class='拾取' order by event_time"
	end if
	rs.open sql,conn,1,1
	HtmlLooted=HtmlLooted& "<table class='outframe interlace'>"
	HtmlLooted=HtmlLooted& "<tr><th colspan='6'><div class='title'><img src='images/icon/axe.jpg'/>物品拾取记录[共搜索到 "&rs.recordcount&" 件]</div><div class='filter'><form method='post' action=''><a href='?'>全部</a><input type='text' name='keyword' value='' /><input type='submit' value='搜索' /></form></div></th></tr>"
	HtmlLooted=HtmlLooted& "<tr class='coltitle'><td>图</td><td>物品</td><td>拾取者</td><td>DKP</td><td>活动</td><td>日期</td></tr>"
	if rs.eof or rs.bof then
		HtmlLooted=HtmlLooted& "<tr><td colspan='6'>暂无物品记录</td></tr>"
	else
		for i = 1 to rs.recordcount
			HtmlLooted=HtmlLooted& "<tr><td>"&eqpic(rs("event_object2"),rs("event_object2_tooltip"))&"</td><td>"&delItemID(rs("event_object2"))&"</td><td>"&id2name(rs("event_object"))&"</td><td>"&rs("event_dkp")&"</td><td>活动</td><td>"&rs("event_time")&"</td></tr>"
		rs.movenext
		next
	end if
	HtmlLooted=HtmlLooted& "</table>"

	Response.write HtmlLooted
	rs.close
End Sub
%>